DECLARE @Count INT
DECLARE @MenuName NVARCHAR(50)
DECLARE @Link NVARCHAR(300)
DECLARE @Desc NVARCHAR(300)
DECLARE @Type NVARCHAR(50)
DECLARE @ParentMenuId INT
DECLARE @SortOrder INT

SET @MenuName = 'Ne'
SET @Link = ''
SET @Desc = ''
SET ParentMenuId = 0
SET @SortOrder = 1

WHILE (@Count <= 47)
BEGIN
	INSERT INTO dbo.Menu
	VALUES  
	(	
		@Count , -- CommunityId - int
		@MenuName , -- MenuName - nvarchar(50)
		@Link , -- Link - nvarchar(300)
		@Desc , -- Desc - nvarchar(300)
		@Type , -- Type - nvarchar(50)
		@ParentMenuId , -- ParentMenuId - int
		@SortOrder , -- SortOrder - int
		1  -- Active - bit
	)
END